I want to create a new Stored Procedure for use in a SQL Agent Job. I would like my new Stored Procedure to appear in the list of Stored Procedures which is visible in SSMS (Databases >> the Database Name >> Progammability >> Stored Procedures >> My new Stored Procudure Name).
I have tried choosing New Stored Procedure and creating my new procedure. When i Save that new procedure, I am prompted to save it as a .sql file on the hard drive. When I do this it does not appear in SSMS.
How do I get a New Stored Procedure to appear in the list of stored procedures in SSMS? My ultimate goal is to use the new Stored Procedure in a SQL Agent Job.